Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
BusinessUnitID (FK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_BSN_UN | Identity | integer | TankReading(DO_RDG_TNK) |
BusinessUnitID (FK)(PK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_BSN_UN | Identity | integer | PhysicalCountDocument(DO_CNT_PHY) |
PhysicalCountDocumentID (FK)(PK) | The identifier for the physical count document on which the actual item counts are recorded. | ID_DCM_PHY_CNT | Identity | integer | PhysicalCountDocument(DO_CNT_PHY) |
PhysicalItemCountLineNumber (PK) | The physical count line item. | IC_CNT_PHY_ITM | LineNumber | smallint | |
LocationID (FK) | A unique system assigned identifier for the Location. | ID_LCN | Identity | integer | InventoryLocation(LO_LCN_INV) |
ItemID (FK) | A unique system assigned identifier for the retailer's SKU. | ID_ITM | IdentityUUID | char(32) | StockItem(AS_ITM_STK) |
TankID (FK) | A unique identifier for this Tank | ID_TNK | Identity | integer | TankReading(DO_RDG_TNK) |
TankProbeID (FK) | A system assigned unique identifier for the TankProbe | ID_PBE_TNK | Identity | integer | TankReading(DO_RDG_TNK) |
ReadingNumber (FK) | A unique identifier for this particular reading on this TankProbe | AI_RDG | LineNumber | smallint | TankReading(DO_RDG_TNK) |
UnitCount | Number of units counted on this line during a phyiscal inventory. | QU_ITM | Quantity | DECIMAL(9,3) | |
CountDateTime | Date and time the count for this line item was performed. | DT_CNT | AuditDateTime | datetime | |
EntryMethodCode | A code that describes how the count was entered (for example, keyed or scanned). | LU_MTH_ID_ENR | Code2 | char(2) | |